Release 10.1A: OpenEdge Data Management:
SQL Reference

ABS

Computes the absolute value of expression.

Syntax

ABS ( expression )

Example

This example illustrates the ABS function:

SELECT ABS (MONTHS_BETWEEN (SYSDATE, order_date))     FROM orders     WHERE ABS (MONTHS_BETWEEN (SYSDATE, order_date)) > 3 ;

Notes

The argument to the function must be of type TINYINT, SMALLINT, INTEGER, NUMERIC, REAL, or FLOAT.
The result is of type NUMERIC.
If the argument expression evaluates to NULL, the result is NULL.

Compatibility

ODBC compatible